2014-01-09 - 10654.100 - Spec - Re-write scorecard SA110 and SA115 to run off of new multiprovider #CrystalReportsSupport

SPECIFICATIONS

10654.100 - Re-write scorecard SA110 and SA115 to run off of new multiprovider

Requirement Summary

Rewrite SA110 and SA115 Scorecard reports using new multiprovider.

Admin Info

Purpose	Rewrite SA110 and SA115 Scorecard reports using New MultiProvider.
Requested By	Mark Harris
Spec Created By	Praveen Guntuka
Spec Created Date	01/20/2014
Spec QA by	Uday Kumar P
Objects	SA110 & SA115
Document Status	Complete

References

Prior Tickets

None

Documents

scorecard.pdf

Functional Requirement

1. Need to redesign the Scorecard Open Order Subreport to reduce the usage of currency converison files and repository functions in Crystal Reports, to increase the performance.
2. Need to use new multiprovider for SA110 and SA115 Scorecard reports.
3. Need to replace excel sheets as datasources with new multiprovider query fields.

Solution Summary

1. Need to update the source for Scorecard main report and subreports.
2. Need to change the formulas accordingly.
3. Need to change the links between Subreports and Main reports and reassign the links using new multiprovider fields.

Test Plan

SNo.	Test Scenario	Expected Results
1	Execute the new Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
2	Schedule the Crystal Report in NEC Infoview.	Report should execute successfully in NEC Infoview.
3	Validate the report with NEC Enterprise production report.	Report should successfully validate with NEC Enterprise production report.

Solution Details

1. Need to update the old queries withe new muliprovider queries.
2. Need to change the formulas accordingly.
3. Need to change the links between subreports and Main report and reassign the links using new multiprovider query fields.
4. Need to update the Parameters.
5. Need to fix the issues if any.
6. Need to include new multiprovider fields in the grouping.
7. Need to check the formatting of the sections and subreports.
8. Need to create region prompt for required subreports in SA115 report.
9. Need to restrict the data based on region prompt in the SA115 report.

Issues

None